'''
# Coding:utf-8
# Project: iiop
# Author: rtf
# Time: 2023-03-24 11:01:32
# FileName: dynamic_excel.py
# Software: PyCharm
'''

insert_rows = {"sheet2": 13, "sheet3": 12, "sheet4": 9, "sheet6": 9, "sheet7": 16, "sheet8": 16, "sheet9": 16,
               "sheet10": 14, "sheet11": 14, "sheet12": 14, "sheet13": 14, "sheet14": 14, "sheet15": 14, "sheet16": 14,
               "sheet17": 14, "sheet18": 14
}


# 项目投资估算表
# sheet0_key = {
#     "in_software_workload": "D3", "in_software_labor_rate": "E3", "in_software_cost": "F3",
#     "in_hardware_workload": "D4", "in_hardware_labor_rate": "E4", "in_hardware_cost": "F4",
#     "in_cdf_workload": "D5", "in_cdf_labor_rate": "E5", "in_cdf_cost": "F5",
#     "in_sfd_workload": "D6", "in_sfd_labor_rate": "E6", "in_sfd_cost": "F6",
#     "in_sid_workload": "D7",  "in_sid_labor_rate": "E7", "in_sid_cost": "F7",
#     "in_si_workload": "D8", "in_si_labor_rate": "E8", "in_si_cost": "F8",
#     "in_sii_workload": "D9", "in_sii_labor_rate": "E9", "in_sii_cost": "F9",
#     "in_boe_workload": "D10", "in_boe_labor_rate": "E10", "in_boe_cost": "F10",
#     "in_dprd_workload": "D11", "in_dprd_labor_rate": "E11", "in_dprd_cost": "F11",
#     "in_dsiccq_workload": "D12", "in_dsiccq_labor_rate": "E12", "in_dsiccq_cost": "F12",
#     "in_duddi_workload": "D13", "in_duddi_labor_rate": "E13", "in_duddi_cost": "F13",
#     "in_other_cost": "F14", "in_total": "F15"
# }
sheet0_key = {
    "in_software_workload": "D3", "in_software_labor_rate": "E3", "in_software_cost": "F3",
    "in_hardware_workload": "D4", "in_hardware_labor_rate": "E4", "in_hardware_cost": "F4",
    "in_cdf_workload": "D5",  "in_cdf_cost": "F5",
    "in_sfd_workload": "D6",  "in_sfd_cost": "F6",
    "in_sid_workload": "D7",  "in_sid_cost": "F7",
    "in_si_workload": "D8",  "in_si_cost": "F8",
    "in_sii_workload": "D9", "in_sii_cost": "F9",
    "in_boe_workload": "D10", "in_boe_cost": "F10",
    "in_dprd_workload": "D11", "in_dprd_cost": "F11",
    "in_dsiccq_workload": "D12", "in_dsiccq_cost": "F12",
    "in_duddi_workload": "D13", "in_duddi_cost": "F13",
    "in_other_cost": "F14", "in_total": "F15"
}

# 咨询设计类
sheet2_key = {
    # 咨询设计工作量及费用总表
    "no": "A13", "work_task": "B13", "chrid_work_task": "C13", "work_describe": "D13", "work_furit": "E13",
    "plan_person": "F13", "plan_day": "G13",
    # 咨询设计工作量基数表
    "1_baseChooseNum": "E19",
    "2_baseChooseNum": "E20",
    "3_baseChooseNum": "E21",
    "4_baseChooseNum": "E22",
    # 初始工作量（人天）
    # "workload_base": "D28",
    # 咨询设计影响因子取值表
    "wType_option": "D34", "wType_explain": "E34", "wType_yzVal": "F34",
    "yxcd_option": "D35", "yxcd_explain": "E35", "yxcd_yzVal": "F35",
    "cgjc_option": "D36", "cgjc_explain": "E36", "cgjc_yzVal": "F36",
    "sjsd_option": "D37", "sjsd_explain": "E37", "sjsd_yzVal": "F37",
    "fayz_option": "D38", "fayz_explain": "E38", "fayz_yzVal": "F38",
    "newApp_option": "D39", "newApp_explain": "E39", "newApp_yzVal": "F39",
    # 咨询设计影响因子计算表
    # "total": "D44",
    # 咨询设计调整工作量计算表
    # "init_workload": "D50",
    # "cd_man_day": "E54",
    # "cd_total": "D59"
}

# 系统开发类-系统功能开发
sheet3_key = {
    # 系统功能开发WBS分解表
    "index": "A12", "xvqiu": "B12", "oneyw": "C12", "secondyw": "D12", "xishu": "E12", "threeyw": "F12",
    "status": "G12", "ywdesc": "H12",
    # 系统软件功能项等级系数表
    "1_xishu": "E18",
    "2_xishu": "E19",
    "3_xishu": "E20",
    "4_xishu": "E21",
    "5_xishu": "E22",
    # 系统功能开发初步工作量测算
    # "sf_min_functional_unit": "D27",
    # "sf_productivity": "D28",
    # "sf_initial_workload": "D29",
    # 系统开发影响因子取值表
    "jsfzd_xsSub_jgcc_yzVal": "F35", "jsfzd_xsSub_jgcc_option": "G35", "jsfzd_xsSub_jgcc_explain": "H35",
    "jsfzd_xsSub_qyzt_yzVal": "F36", "jsfzd_xsSub_qyzt_option": "G36", "jsfzd_xsSub_qyzt_explain": "H36",
    "jsfzd_xsSub_xtjcqk_yzVal": "F37", "jsfzd_xsSub_xtjcqk_option": "G37", "jsfzd_xsSub_xtjcqk_explain": "H37",
    "jsfzd_xsSub_apptype_yzVal": "F38", "jsfzd_xsSub_apptype_option": "G38", "jsfzd_xsSub_apptype_explain": "H38",
    "jsfzd_xsSub_zbdj_yzVal": "F39", "jsfzd_xsSub_zbdj_option": "G39", "jsfzd_xsSub_zbdj_explain": "H39",
    "jsfzd_xsSub_njsapp_yzVal": "F40", "jsfzd_xsSub_njsapp_option": "G40", "jsfzd_xsSub_njsapp_explain": "H40",
    "jsfzd_xsSub_wyy_yzVal": "F41", "jsfzd_xsSub_wyy_option": "G41", "jsfzd_xsSub_wyy_explain": "H41",
    "jsfzd_xsSub_mxsf_yzVal": "F42", "jsfzd_xsSub_mxsf_option": "G42", "jsfzd_xsSub_mxsf_explain": "H42",

    "ywfzd_xsSub_ywzsfz_yzVal": "F43", "ywfzd_xsSub_ywzsfz_option": "G43", "ywfzd_xsSub_ywzsfz_explain": "H43",
    "ywfzd_xsSub_usetype_yzVal": "F44", "ywfzd_xsSub_usetype_option": "G44", "ywfzd_xsSub_usetype_explain": "H44",
    "ywfzd_xsSub_kywkj_yzVal": "F45", "ywfzd_xsSub_kywkj_option": "G45", "ywfzd_xsSub_kywkj_explain": "H45",
    "ywfzd_xsSub_ywcs_yzVal": "F46", "ywfzd_xsSub_ywcs_option": "G46", "ywfzd_xsSub_ywcs_explain": "H46",
    "ywfzd_xsSub_ywtype_yzVal": "F47", "ywfzd_xsSub_ywtype_option": "G47", "ywfzd_xsSub_ywtype_explain": "H47",
    "ywfzd_xsSub_gxdzdev_yzVal": "F48", "ywfzd_xsSub_gxdzdev_option": "G48", "ywfzd_xsSub_gxdzdev_explain": "H48",
    "ywfzd_xsSub_yhjh_yzVal": "F49", "ywfzd_xsSub_yhjh_option": "G49", "ywfzd_xsSub_yhjh_explain": "H49",
    "ywfzd_xsSub_ycsj_yzVal": "F50", "ywfzd_xsSub_ycsj_option": "G50", "ywfzd_xsSub_ycsj_explain": "H50",

    "ywcznl_xsSub_hyyh_yzVal": "F51", "ywcznl_xsSub_hyyh_option": "G51", "ywcznl_xsSub_hyyh_explain": "H51",
    "ywcznl_xsSub_zdbf_yzVal": "F52", "ywcznl_xsSub_zdbf_option": "G52", "ywcznl_xsSub_zdbf_explain": "H52",
    "ywcznl_xsSub_ywjsx_yzVal": "F53", "ywcznl_xsSub_ywjsx_option": "G53", "ywcznl_xsSub_ywjsx_explain": "H53",
    "ywcznl_xsSub_gky_yzVal": "F54", "ywcznl_xsSub_gky_option": "G54", "ywcznl_xsSub_gky_explain": "H54",
    "ywcznl_xsSub_sjgm_yzVal": "F55", "ywcznl_xsSub_sjgm_option": "G55", "ywcznl_xsSub_sjgm_explain": "H55",
    "ywcznl_xsSub_gzcjr_yzVal": "F56", "ywcznl_xsSub_gzcjr_option": "G56", "ywcznl_xsSub_gzcjr_explain": "H56",

    "aqfhfzd_xsSub_aqfhyq_yzVal": "F57", "aqfhfzd_xsSub_aqfhyq_option": "G57", "aqfhfzd_xsSub_aqfhyq_explain": "H57",
    "aqfhfzd_xsSub_aqfhdj_yzVal": "F58", "aqfhfzd_xsSub_aqfhdj_option": "G58", "aqfhfzd_xsSub_aqfhdj_explain": "H58",
    "xtgjnd_xsSub_xtgj_yzVal": "F59", "xtgjnd_xsSub_xtgj_option": "G59", "xtgjnd_xsSub_xtgj_explain": "H59",
    "yhhyd_xsSub_yhhyd_yzVal": "F60", "yhhyd_xsSub_yhhyd_option": "G60", "yhhyd_xsSub_yhhyd_explain": "H60",

    # "sf_if_total": "D116",
    # ####咨询设计调整工作量计算表###
    # "sf_init_workload": "D121",
    ###########################
    # "sf_man_day": "E73",
    # "sf_total": "D129"
}

# 系统开发类-系统集成开发
sheet4_key = {
    # 根据集成开发WBS分解表，明确系统集成开发任务和子任务
    "no": "A9", "system_name": "B9", "jcStatus": "C9", "dataContent": "D9", "baseNum": "E9", "forceNum": "F9",
    "remark": "G9",
    # #######初步工作量#########
    "si_init_workload": "D19",
    ##########################
    # "si_final_workload": "E27",
    # "si_cost": "D32"
}

# 系统实施
sheet5_key = {
    # 根据系统实施WBS分解表，明确系统实施工作各项任务
    # "implementation_scope": "C4",
    "provinceNum": "F7",  "unitCityNum": "G7",

    "s_1.1_baseChooseNum": "F10", "zs_1.1_baseChooseNum": "G10",
    "s_1.2_baseChooseNum": "F11", "zs_1.2_baseChooseNum": "G11",
    "s_1.3_baseChooseNum": "F12", "zs_1.3_baseChooseNum": "G12",

    "s_2.1_baseChooseNum": "F14", "zs_2.1_baseChooseNum": "G14",
    "s_2.2_baseChooseNum": "F15", "zs_2.2_baseChooseNum": "G15",
    "s_2.3_baseChooseNum": "F16", "zs_2.3_baseChooseNum": "G16",

    "s_3.1_baseChooseNum": "F18", "zs_3.1_baseChooseNum": "G18",
    "s_3.2_baseChooseNum": "F19", "zs_3.2_baseChooseNum": "G19",
    "s_3.3_baseChooseNum": "F20", "zs_3.3_baseChooseNum": "G20",

    "s_4.1_baseChooseNum": "F22", "zs_4.1_baseChooseNum": "G22",
    "s_4.2_baseChooseNum": "F23", "zs_4.2_baseChooseNum": "G23",

    "s_5.1_baseChooseNum": "F25", "zs_5.1_baseChooseNum": "G25",
    "s_5.2_baseChooseNum": "F26", "zs_5.2_baseChooseNum": "G26",
    "s_5.3_baseChooseNum": "F27", "zs_5.3_baseChooseNum": "G27",
    "s_5.4_baseChooseNum": "F28", "zs_5.4_baseChooseNum": "G28",

    "s_6.1_baseChooseNum": "F31", "zs_6.1_baseChooseNum": "G31",
    "s_6.2_baseChooseNum": "F32", "zs_6.2_baseChooseNum": "G32",
    "s_6.3_baseChooseNum": "F33", "zs_6.3_baseChooseNum": "G33",

    "s_7.1_baseChooseNum": "F35", "zs_7.1_baseChooseNum": "G35",
    "s_7.2_baseChooseNum": "F36", "zs_7.2_baseChooseNum": "G36",

    # 此为系统实施一级工作任务工作量基数表
    "1.1_baseChooseNum": "F43", "1.2_baseChooseNum": "F44", "1.3_baseChooseNum": "F45",
    "2.1_baseChooseNum": "F47", "2.2_baseChooseNum": "F48", "2.3_baseChooseNum": "F49",
    "3.1_baseChooseNum": "F51", "3.2_baseChooseNum": "F52", "3.3_baseChooseNum": "F53",
    "4.1_baseChooseNum": "F55", "4.2_baseChooseNum": "F56", "5.1_baseChooseNum": "F58",
    "5.2_baseChooseNum": "F59", "5.3_baseChooseNum": "F60", "5.4_baseChooseNum": "F61",
    "6.1_baseChooseNum": "F63", "6.2_baseChooseNum": "F64", "6.3_baseChooseNum": "F65",
    "7.1_baseChooseNum": "F67", "7.2_baseChooseNum": "F68",
    # 系统实施影响因子取值表
    "ssfzd_xsSub_ssgzfw_yzVal": "F80", "ssfzd_xsSub_ssgzfw_option": "G80", "ssfzd_xsSub_ssgzfw_explain": "H80",
    "ssfzd_xsSub_yylx_yzVal": "F81", "ssfzd_xsSub_yylx_option": "G81", "ssfzd_xsSub_yylx_explain": "H81",
    "ssfzd_xsSub_ywcsd_yzVal": "F82", "ssfzd_xsSub_ywcsd_option": "G82", "ssfzd_xsSub_ywcsd_explain": "H82",
    "ssfzd_xsSub_zbdj_yzVal": "F83", "ssfzd_xsSub_zbdj_option": "G83", "ssfzd_xsSub_zbdj_explain": "H83",
    "ssfzd_xsSub_njsapp_yzVal": "F84", "ssfzd_xsSub_njsapp_option": "G84", "ssfzd_xsSub_njsapp_explain": "H84",
    "ssfzd_xsSub_gzcywzc_yzVal": "F85", "ssfzd_xsSub_gzcywzc_option": "G85", "ssfzd_xsSub_gzcywzc_explain": "H85",
    "ssfzd_xsSub_syxtz_yzVal": "F86", "ssfzd_xsSub_syxtz_option": "G86", "ssfzd_xsSub_syxtz_explain": "H86",
    "ssfzd_xsSub_fgnty_yzVal": "F87", "ssfzd_xsSub_fgnty_option": "G87", "ssfzd_xsSub_fgnty_explain": "H87",
    "sjsjzl_xsSub_kzycj_yzVal": "F88", "sjsjzl_xsSub_kzycj_option": "G88", "sjsjzl_xsSub_kzycj_explain": "H88",
    "sjsjzl_xsSub_xccjnum_yzVal": "F89", "sjsjzl_xsSub_xccjnum_option": "G89", "sjsjzl_xsSub_xccjnum_explain": "H89",
    "sjsjzl_xsSub_cjdx_yzVal": "F90", "sjsjzl_xsSub_cjdx_option": "G90", "sjsjzl_xsSub_cjdx_explain": "H90",
    "aqfhfzd_xsSub_aqfhyq_yzVal": "F91", "aqfhfzd_xsSub_aqfhyq_option": "G91", "aqfhfzd_xsSub_aqfhyq_explain": "H91",
    "aqfhfzd_xsSub_aqfhdj_yzVal": "F92", "aqfhfzd_xsSub_aqfhdj_option": "G92", "aqfhfzd_xsSub_aqfhdj_explain": "H92",
    "xtgjnd_xsSub_xtgj_yzVal": "F93", "xtgjnd_xsSub_xtgj_option": "G93", "xtgjnd_xsSub_xtgj_explain": "H93",
    "yhhyd_xsSub_yhhyd_yzVal": "F94", "yhhyd_xsSub_yhhyd_option": "G94", "yhhyd_xsSub_yhhyd_explain": "H94",
    # 计算系统实施因子得分######
    # "sii_xtss_yxyz": "D124",
    # "sii_xtss_tzgzl": "D129",
    #########################
    # "sii_table_workload_total": "E107",
    # "sii_table_cost_total": "D137"

}

# 系统集成实施
sheet6_key = {
    # 根据集成实施WBS分解表，明确系统集成实施任务和子任务
    "no": "A9", "system_name": "B9", "jcStatus": "C9", "dataContent": "D9", "baseNum": "E9", "forceNum": "F9",
    "remark": "G9",
    # ##########初步工作量############
    "si_impl_init_workload": "D14",
    ###############################
    # "si_impl_final_workload": "E23",
    # "si_impl_cost": "D28"
}

# 业务运营-应用上云
sheet7_key = {
    # 根据业务运营WBS分解表，明确业务运营工作各项任务
    "no": "A16", "work_type": "B16", "work_task": "C16", "work_describe": "D16", "final_workload": "F16",
    "scope": "G16",
    "bo_scope_top": "C14",
    "1_baseChooseNum": "E21",
    "2_baseChooseNum": "E22",
    "3_baseChooseNum": "E23",
    "4_baseChooseNum": "E24",
    "5_baseChooseNum": "E25",
    "6_baseChooseNum": "E26",
    "7_baseChooseNum": "E27",
    "8_baseChooseNum": "E28",
    "9_baseChooseNum": "E29",

    # "bo_workload": "D35",
    # "bo_final_workload": "E45",
    # "bo_cost": "D50"
}

# 业务运营-性能优化
sheet8_key = {
    # 根据业务运营WBS分解表，明确业务运营工作各项任务
    "no": "A16", "work_type": "B16", "work_task": "C16", "work_describe": "D16", "final_workload": "F16",
    "scope": "G16",
    "bo_scope_top": "C14",
    "1_baseChooseNum": "F21",
    "2_baseChooseNum": "F22",
    "3_baseChooseNum": "F23",
    "4_baseChooseNum": "F24",
    "5_baseChooseNum": "F25",
    "6_baseChooseNum": "F26",
    "7_baseChooseNum": "F27",
    "8_baseChooseNum": "F28",
    "9_baseChooseNum": "F29",
    "10_baseChooseNum": "F30",
    "11_baseChooseNum": "F31",
    "12_baseChooseNum": "F32",
    "13_baseChooseNum": "F33",

    "xsSub_jgcc_yzVal": "F45", "xsSub_jgcc_option": "G45", "xsSub_jgcc_explain": "H45",
    "xsSub_xtjgbh_yzVal": "F46", "xsSub_xtjgbh_option": "G46", "xsSub_xtjgbh_explain": "H46",
    "xcxt_xsSub_xcxt_yzVal": "F47", "xcxt_xsSub_xcxt_option": "G47", "xcxt_xsSub_xcxt_explain": "H47",
    "yygm_xsSub_yygm_yzVal": "F48", "yygm_xsSub_yygm_option": "G48", "yygm_xsSub_yygm_explain": "H48",

    # "bo_final_workload": "E63",
    # "bo_cost": "D68"

}

# 业务运营-常态常规信息支撑
sheet9_key = {
    # 根据业务运营WBS分解表，明确业务运营工作各项任务
    "no": "A16", "work_type": "B16", "work_task": "C16", "work_describe": "D16", "work_fruit": "E16",
    "plan_preson": "F16", "plan_tlpro": "G16", "final_workload": "H16", "scope": "I16",
    "bo_scope_top": "C14",
    "bo_workload": "C20",
    # 运营范围
    "bo_scope": "C21"

}

# 数据工程类-数据接入
sheet10_key = {
    # 根据业务运营WBS分解表，明确业务运营工作各项任务
    "no": "A14", "work_type": "B14", "work_task": "C14", "work_describe": "D14", "plan_person": "F14",
    "final_workload": "G14", "scope": "H14",
    "bo_scope_top": "C12",
    "engineering_scope_top": "C12",
    "1_baseChooseNum": "F20",
    "2_baseChooseNum": "F21",
    "3_baseChooseNum": "F22",
    "4_baseChooseNum": "F23",
    "5_baseChooseNum": "F24",
    "6_baseChooseNum": "F25",
    "7_baseChooseNum": "F26",
    "8_baseChooseNum": "F27",
    "9_baseChooseNum": "F28",
    "10_baseChooseNum": "F29",
    "11_baseChooseNum": "F30",

    "sjbgm_option": "E42", "sjbgm_yzVal": "F42",  "sjbgm_explain": "G42",
    "sjlxfzd_option": "E47", "sjlxfzd_yzVal": "F47",  "sjlxfzd_explain": "G47",
    "xtlx_option": "E53", "xtlx_yzVal": "F53",  "xtlx_explain": "G53",
    "kdywkj_option": "E57", "kdywkj_yzVal": "F57",  "kdywkj_explain": "G57",
    "qzcg_option": "E62", "qzcg_yzVal": "F62",  "qzcg_explain": "G62",
    "gcgm_option": "E65", "gcgm_yzVal": "F65",  "gcgm_explain": "G65",

    # "de_final_workload": "E82",
    # "de_cost": "D87"
}

# 数据工程类-数据标准化
sheet11_key = {
    # 根据业务运营WBS分解表，明确业务运营工作各项任务
    "no": "A14", "work_type": "B14", "work_task": "C14", "work_describe": "D14", "plan_person": "F14",
    "final_workload": "G14", "scope": "H14",
    "bo_scope_top": "C12",
    "1_baseChooseNum": "F20",
    "2_baseChooseNum": "F21",
    "3_baseChooseNum": "F22",
    "4_baseChooseNum": "F23",
    "5_baseChooseNum": "F24",
    "6_baseChooseNum": "F25",
    "7_baseChooseNum": "F26",
    "8_baseChooseNum": "F27",
    "9_baseChooseNum": "F28",

    "sjbgm_option": "E40", "sjbgm_yzVal": "F40",  "sjbgm_explain": "G40",
    "sjlxfzd_option": "E45", "sjlxfzd_yzVal": "F45",  "sjlxfzd_explain": "G45",
    "xtlx_option": "E51", "xtlx_yzVal": "F51",  "xtlx_explain": "G51",
    "kdywkj_option": "E55", "kdywkj_yzVal": "F55",  "kdywkj_explain": "G55",
    "qzcg_option": "E60", "qzcg_yzVal": "F60",  "qzcg_explain": "G60",
    "gcgm_option": "E63", "gcgm_yzVal": "F63",  "gcgm_explain": "G63",

    # "de_final_workload": "E80",
    # "de_cost": "D85"

}

# 数据工程类-数据上传
sheet12_key = {
    # 根据业务运营WBS分解表，明确业务运营工作各项任务
    "no": "A14", "work_type": "B14", "work_task": "C14", "work_describe": "D14", "plan_person": "F14",
    "final_workload": "G14", "scope": "H14",
    "bo_scope_top": "C12",
    "1_baseChooseNum": "F20",
    "2_baseChooseNum": "F21",
    "3_baseChooseNum": "F22",
    "4_baseChooseNum": "F23",
    "5_baseChooseNum": "F24",
    "6_baseChooseNum": "F25",
    "7_baseChooseNum": "F26",
    "8_baseChooseNum": "F27",
    "9_baseChooseNum": "F28",
    "10_baseChooseNum": "F29",

    "sjbgm_option": "E41", "sjbgm_yzVal": "F41",  "sjbgm_explain": "G41",
    "sjlxfzd_option": "E46", "sjlxfzd_yzVal": "F46",  "sjlxfzd_explain": "G46",
    "xtlx_option": "E52", "xtlx_yzVal": "F52",  "xtlx_explain": "G52",
    "kdywkj_option": "E56", "kdywkj_yzVal": "F56",  "kdywkj_explain": "G56",
    "qzcg_option": "E61", "qzcg_yzVal": "F61",  "qzcg_explain": "G61",
    "gcgm_option": "E64", "gcgm_yzVal": "F64",  "gcgm_explain": "G64",

    # "de_final_workload": "E81",
    # "de_cost": "D86"

}

# 数据工程类-数据下发
sheet13_key = {
    # 根据业务运营WBS分解表，明确业务运营工作各项任务
    "no": "A14", "work_type": "B14", "work_task": "C14", "work_describe": "D14", "plan_person": "F14",
    "final_workload": "G14", "scope": "H14",
    "bo_scope_top": "C12",
    "1_baseChooseNum": "F20",
    "2_baseChooseNum": "F21",
    "3_baseChooseNum": "F22",
    "4_baseChooseNum": "F23",
    "5_baseChooseNum": "F24",
    "6_baseChooseNum": "F25",
    "7_baseChooseNum": "F26",
    "8_baseChooseNum": "F27",
    "9_baseChooseNum": "F28",

    "sjbgm_option": "E40", "sjbgm_yzVal": "F40",  "sjbgm_explain": "G40",
    "sjlxfzd_option": "E45", "sjlxfzd_yzVal": "F45",  "sjlxfzd_explain": "G45",
    "xtlx_option": "E51", "xtlx_yzVal": "F51",  "xtlx_explain": "G51",
    "kdywkj_option": "E55", "kdywkj_yzVal": "F55",  "kdywkj_explain": "G55",
    "qzcg_option": "E60", "qzcg_yzVal": "F60",  "qzcg_explain": "G60",
    "gcgm_option": "E63", "gcgm_yzVal": "F63",  "gcgm_explain": "G63",

    # "de_final_workload": "E80",
    # "de_cost": "D85"
}

# 数据工程类-数据盘点
sheet14_key = {
    # 根据业务运营WBS分解表，明确业务运营工作各项任务
    "no": "A14", "work_type": "B14", "work_task": "C14", "work_describe": "D14", "plan_person": "F14",
    "final_workload": "G14", "scope": "H14",
    "bo_scope_top": "C12",
    "1_baseChooseNum": "F20",
    "2_baseChooseNum": "F21",
    "3_baseChooseNum": "F22",
    "4_baseChooseNum": "F23",
    "5_baseChooseNum": "F24",
    "6_baseChooseNum": "F25",
    "7_baseChooseNum": "F26",
    "8_baseChooseNum": "F27",
    "9_baseChooseNum": "F28",

    "sjbgm_option": "E40", "sjbgm_yzVal": "F40",  "sjbgm_explain": "G40",
    "sjlxfzd_option": "E45", "sjlxfzd_yzVal": "F45",  "sjlxfzd_explain": "G45",
    "xtlx_option": "E51", "xtlx_yzVal": "F51",  "xtlx_explain": "G51",
    "kdywkj_option": "E55", "kdywkj_yzVal": "F55",  "kdywkj_explain": "G55",
    "qzcg_option": "E60", "qzcg_yzVal": "F60",  "qzcg_explain": "G60",
    "gcgm_option": "E63", "gcgm_yzVal": "F63",  "gcgm_explain": "G63",

    # "de_final_workload": "E80",
    # "de_cost": "D85"
}

# 数据工程类-数据资源目录构造
sheet15_key = {
    # 根据业务运营WBS分解表，明确业务运营工作各项任务
    "no": "A14", "work_type": "B14", "work_task": "C14", "work_describe": "D14", "plan_person": "F14",
    "final_workload": "G14", "scope": "H14",
    "bo_scope_top": "C12",
    "1_baseChooseNum": "F20",
    "2_baseChooseNum": "F21",
    "3_baseChooseNum": "F22",
    "4_baseChooseNum": "F23",
    "5_baseChooseNum": "F24",
    "6_baseChooseNum": "F25",
    "7_baseChooseNum": "F26",
    "8_baseChooseNum": "F27",
    "9_baseChooseNum": "F28",
    "10_baseChooseNum": "F29",

    "sjbgm_option": "E41", "sjbgm_yzVal": "F41",  "sjbgm_explain": "G41",
    "sjlxfzd_option": "E46", "sjlxfzd_yzVal": "F46",  "sjlxfzd_explain": "G46",
    "xtlx_option": "E52", "xtlx_yzVal": "F52",  "xtlx_explain": "G52",
    "kdywkj_option": "E56", "kdywkj_yzVal": "F56",  "kdywkj_explain": "G56",
    "qzcg_option": "E61", "qzcg_yzVal": "F61",  "qzcg_explain": "G61",
    "gcgm_option": "E64", "gcgm_yzVal": "F64",  "gcgm_explain": "G64",

    # "de_final_workload": "E81",
    # "de_cost": "D86"
}

# 数据工程类-数据质量治理
sheet16_key = {
    # 根据业务运营WBS分解表，明确业务运营工作各项任务
    "no": "A14", "work_type": "B14", "work_task": "C14", "work_describe": "D14", "plan_person": "F14",
    "final_workload": "G14", "scope": "H14",
    "bo_scope_top": "C12",
    "1_baseChooseNum": "F20",
    "2_baseChooseNum": "F21",
    "3_baseChooseNum": "F22",
    "4_baseChooseNum": "F23",
    "5_baseChooseNum": "F24",
    "6_baseChooseNum": "F25",
    "7_baseChooseNum": "F26",
    "8_baseChooseNum": "F27",
    "9_baseChooseNum": "F28",

    "sjbgm_option": "E40", "sjbgm_yzVal": "F40",  "sjbgm_explain": "G40",
    "sjlxfzd_option": "E45", "sjlxfzd_yzVal": "F45",  "sjlxfzd_explain": "G45",
    "xtlx_option": "E51", "xtlx_yzVal": "F51",  "xtlx_explain": "G51",
    "kdywkj_option": "E55", "kdywkj_yzVal": "F55",  "kdywkj_explain": "G55",
    "qzcg_option": "E60", "qzcg_yzVal": "F60",  "qzcg_explain": "G60",
    "gcgm_option": "E63", "gcgm_yzVal": "F63",  "gcgm_explain": "G63",

    # "de_final_workload": "E80",
    # "de_cost": "D85"
}

# 数据工程类-数据产品（应用）研发及实施
sheet17_key = {
    # 根据业务运营WBS分解表，明确业务运营工作各项任务
    "no": "A14", "work_type": "B14", "work_task": "C14", "work_describe": "D14", "plan_person": "F14",
    "final_workload": "G14", "scope": "H14",
    "bo_scope_top": "C12",
    "sjcpyfWbs_1_baseChooseNumYfyy": "H20", "sjcpyfWbs_1_baseChooseNumYfzs": "I20",
    "sjcpyfWbs_2_baseChooseNumYfyy": "H21", "sjcpyfWbs_2_baseChooseNumYfzs": "I21",
    "sjcpyfWbs_3_baseChooseNumYfyy": "H22", "sjcpyfWbs_3_baseChooseNumYfzs": "I22",
    "sjcpyfWbs_4_baseChooseNumYfyy": "H23", "sjcpyfWbs_4_baseChooseNumYfzs": "I23",
    "sjcpyfWbs_5_baseChooseNumYfyy": "H24", "sjcpyfWbs_5_baseChooseNumYfzs": "I24",
    "sjcpyfWbs_6_baseChooseNumYfyy": "H25", "sjcpyfWbs_6_baseChooseNumYfzs": "I25",
    "sjcpyfWbs_7_baseChooseNumYfyy": "H26", "sjcpyfWbs_7_baseChooseNumYfzs": "I26",
    "sjcpyfWbs_8_baseChooseNumYfyy": "H27", "sjcpyfWbs_8_baseChooseNumYfzs": "I27",
    "sjcpyfWbs_9_baseChooseNumYfyy": "H28", "sjcpyfWbs_9_baseChooseNumYfzs": "I28",
    "sjcpyfWbs_10_baseChooseNumYfyy": "H29", "sjcpyfWbs_10_baseChooseNumYfzs": "I29",
    "sjcpyfWbs_11_baseChooseNumYfyy": "H30", "sjcpyfWbs_11_baseChooseNumYfzs": "I30",
    "sjcpyfWbs_12_baseChooseNumYfyy": "H31", "sjcpyfWbs_12_baseChooseNumYfzs": "I31",
    "sjcpyfWbs_13_baseChooseNumYfyy": "H32", "sjcpyfWbs_13_baseChooseNumYfzs": "I32",
    "sjcpyfWbs_14_baseChooseNumYfyy": "H33", "sjcpyfWbs_14_baseChooseNumYfzs": "I33",
    "sjcpyfWbs_15_baseChooseNumYfyy": "H34", "sjcpyfWbs_15_baseChooseNumYfzs": "I34",
    "sjcpyfWbs_16_baseChooseNumYfyy": "H35", "sjcpyfWbs_16_baseChooseNumYfzs": "I35",
    "sjcpyfWbs_17_baseChooseNumYfyy": "H36", "sjcpyfWbs_17_baseChooseNumYfzs": "I36",
    "sjcpyfWbs_18_baseChooseNumYfyy": "H37", "sjcpyfWbs_18_baseChooseNumYfzs": "I37",
    "sjcpyfWbs_19_baseChooseNumYfyy": "H38", "sjcpyfWbs_19_baseChooseNumYfzs": "I38",
    "sjcpssWbs_1_baseChooseNumSsyy": "J39", "sjcpssWbs_1_baseChooseNumSszs": "K39",
    "sjcpssWbs_2_baseChooseNumSsyy": "J40", "sjcpssWbs_2_baseChooseNumSszs": "K40",
    "sjcpssWbs_3_baseChooseNumSsyy": "J41", "sjcpssWbs_3_baseChooseNumSszs": "K41",
    "sjcpssWbs_4_baseChooseNumSsyy": "J42", "sjcpssWbs_4_baseChooseNumSszs": "K42",
    "sjcpssWbs_5_baseChooseNumSsyy": "J43", "sjcpssWbs_5_baseChooseNumSszs": "K43",

    "sffzd_option": "D56", "sffzd_yzVal": "E56",  "sffzd_explain": "F56",
    "sjbgm_option": "D61", "sjbgm_yzVal": "E61",  "sjbgm_explain": "F61",
    "kdywkj_option": "D67", "kdywkj_yzVal": "E67",  "kdywkj_explain": "F67",
    "sjhqfzd_option": "D71", "sjhqfzd_yzVal": "E71",  "sjhqfzd_explain": "F71",
    "yyzxpc_option": "D76", "yyzxpc_yzVal": "E76",  "yyzxpc_explain": "F76",
    "gcgm_option": "D79", "gcgm_yzVal": "E79",  "gcgm_explain": "F79",
    "dwfw_option": "D80", "dwfw_yzVal": "E80",  "dwfw_explain": "F80",
    "dpksh_option": "D81", "dpksh_yzVal": "E81",  "dpksh_explain": "F81",

    #############################################################
    # "yf_de_final_workload": "E99", "ss_de_final_workload": "K99"
    #############################################################

}

